package com.service;


import com.entity.Clerk;
import com.result.QueryResult;

import java.sql.SQLException;

/**
 * @author lenovo
 */
public interface ClerkService {
    /**
     * @param offset 0,10,20偏移量
     * @param size 每页的记录数
     * @return  集合
     */
    QueryResult selectByPage(Integer offset, Integer size) ;

    /**
     * @param clerk
     * @return
     * @throws SQLException
     */
    Clerk add(Clerk clerk) throws SQLException;

    /**
     * @param id
     * @return
     */
    Integer delete(Integer id);

    /**
     * @param clerk
     */
    void update(Clerk clerk);

    /**
     * @param searchName
     * @return
     */
    QueryResult searchLikeName(String searchName,Integer offset, Integer size);
}
